﻿ 
 

using System.Data;
using System.Data.Common;
using System.Collections.Generic;

using Churchtoolkit.DataAccess;
using Churchtoolkit.DataAccess.Common;
using Churchtoolkit.DataAccess.Entities;
namespace Churchtoolkit.DataAccess.Repositories
{	
	#region [ MembersInModulesRepository ]
	/// <summary>
	/// Repository for CRUD operations on MembersInModules table 
	/// </summary>
	public class MembersInModulesRepository : RepositoryBase< MembersInModules,MembersInModulesIdentity,MembersInModulesColumns >
	{
	 public MembersInModulesRepository(string connectionStringName) : base(connectionStringName) { }
		protected override IEnumerable<System.Data.Common.DbParameter> GetInsertParameters(MembersInModules entity)
		{
							yield return CreateParameter("MemberId",entity.MemberId);
								yield return CreateParameter("ModuleId",entity.ModuleId);
						}
		protected override IEnumerable<System.Data.Common.DbParameter> GetUpdateParameters(MembersInModules entity)
		{
							yield return CreateParameter("MemberId",entity.MemberId);
							yield return CreateParameter("ModuleId",entity.ModuleId);
					}
		protected override IEnumerable<System.Data.Common.DbParameter> GetDeleteParameters(MembersInModulesIdentity identity)
		{
				
				yield return CreateParameter("MemberId",identity.MemberId);
				
				yield return CreateParameter("ModuleId",identity.ModuleId);
					}
        protected override string InsertProc
        {
            get { return "SP_MembersInModules_Insert";}
		}
		
		protected override string UpdateProc
        {
            get { return "SP_MembersInModules_Update";}
		}
		
		protected override string DeleteProc
        {
            get { return "SP_MembersInModules_Delete";}
		}
		
		protected override string SelectProc
        {
            get { return "SP_MembersInModules_Select";}
		}
		}
		#endregion
	
	#region [ MemberPhonesRepository ]
	/// <summary>
	/// Repository for CRUD operations on MemberPhones table 
	/// </summary>
	public class MemberPhonesRepository : RepositoryBase< MemberPhones,System.Int32,MemberPhonesColumns >
	{
	 public MemberPhonesRepository(string connectionStringName) : base(connectionStringName) { }
		protected override IEnumerable<System.Data.Common.DbParameter> GetInsertParameters(MemberPhones entity)
		{
							yield return CreateParameter("MemberId",entity.MemberId);
								yield return CreateParameter("Phone",entity.Phone);
									yield return CreateParameter("PhoneId",0,ParameterDirection.ReturnValue);
								yield return CreateParameter("PhoneType",entity.PhoneType);
						}
		protected override IEnumerable<System.Data.Common.DbParameter> GetUpdateParameters(MemberPhones entity)
		{
							yield return CreateParameter("MemberId",entity.MemberId);
							yield return CreateParameter("Phone",entity.Phone);
							yield return CreateParameter("PhoneId",entity.PhoneId);
							yield return CreateParameter("PhoneType",entity.PhoneType);
					}
		protected override IEnumerable<System.Data.Common.DbParameter> GetDeleteParameters(System.Int32 identity)
		{
							yield return CreateParameter("PhoneId",identity);
					}
        protected override string InsertProc
        {
            get { return "SP_MemberPhones_Insert";}
		}
		
		protected override string UpdateProc
        {
            get { return "SP_MemberPhones_Update";}
		}
		
		protected override string DeleteProc
        {
            get { return "SP_MemberPhones_Delete";}
		}
		
		protected override string SelectProc
        {
            get { return "SP_MemberPhones_Select";}
		}
		}
		#endregion
	
	#region [ MembersRepository ]
	/// <summary>
	/// Repository for CRUD operations on Members table 
	/// </summary>
	public class MembersRepository : RepositoryBase< Members,System.Int32,MembersColumns >
	{
	 public MembersRepository(string connectionStringName) : base(connectionStringName) { }
		protected override IEnumerable<System.Data.Common.DbParameter> GetInsertParameters(Members entity)
		{
							yield return CreateParameter("Birthdate",entity.Birthdate);
								yield return CreateParameter("ConfessionFather",entity.ConfessionFather);
								yield return CreateParameter("CountryId",entity.CountryId);
								yield return CreateParameter("CreationDate",entity.CreationDate);
								yield return CreateParameter("DisplayName",entity.DisplayName);
								yield return CreateParameter("Email",entity.Email);
								yield return CreateParameter("FirstName",entity.FirstName);
								yield return CreateParameter("Gender",entity.Gender);
								yield return CreateParameter("ImagePath",entity.ImagePath);
								yield return CreateParameter("IsActive",entity.IsActive);
								yield return CreateParameter("LastName",entity.LastName);
								yield return CreateParameter("LastUpdateDate",entity.LastUpdateDate);
									yield return CreateParameter("MemberId",0,ParameterDirection.ReturnValue);
								yield return CreateParameter("NationalityId",entity.NationalityId);
								yield return CreateParameter("Password",entity.Password);
						}
		protected override IEnumerable<System.Data.Common.DbParameter> GetUpdateParameters(Members entity)
		{
							yield return CreateParameter("Birthdate",entity.Birthdate);
							yield return CreateParameter("ConfessionFather",entity.ConfessionFather);
							yield return CreateParameter("CountryId",entity.CountryId);
							yield return CreateParameter("CreationDate",entity.CreationDate);
							yield return CreateParameter("DisplayName",entity.DisplayName);
							yield return CreateParameter("Email",entity.Email);
							yield return CreateParameter("FirstName",entity.FirstName);
							yield return CreateParameter("Gender",entity.Gender);
							yield return CreateParameter("ImagePath",entity.ImagePath);
							yield return CreateParameter("IsActive",entity.IsActive);
							yield return CreateParameter("LastName",entity.LastName);
							yield return CreateParameter("LastUpdateDate",entity.LastUpdateDate);
							yield return CreateParameter("MemberId",entity.MemberId);
							yield return CreateParameter("NationalityId",entity.NationalityId);
							yield return CreateParameter("Password",entity.Password);
					}
		protected override IEnumerable<System.Data.Common.DbParameter> GetDeleteParameters(System.Int32 identity)
		{
							yield return CreateParameter("MemberId",identity);
					}
        protected override string InsertProc
        {
            get { return "SP_Members_Insert";}
		}
		
		protected override string UpdateProc
        {
            get { return "SP_Members_Update";}
		}
		
		protected override string DeleteProc
        {
            get { return "SP_Members_Delete";}
		}
		
		protected override string SelectProc
        {
            get { return "SP_Members_Select";}
		}
		}
		#endregion
	
	#region [ MemberAddressesRepository ]
	/// <summary>
	/// Repository for CRUD operations on MemberAddresses table 
	/// </summary>
	public class MemberAddressesRepository : RepositoryBase< MemberAddresses,System.Int32,MemberAddressesColumns >
	{
	 public MemberAddressesRepository(string connectionStringName) : base(connectionStringName) { }
		protected override IEnumerable<System.Data.Common.DbParameter> GetInsertParameters(MemberAddresses entity)
		{
								yield return CreateParameter("AddressId",0,ParameterDirection.ReturnValue);
								yield return CreateParameter("AppartmentNumber",entity.AppartmentNumber);
								yield return CreateParameter("BuildingNumber",entity.BuildingNumber);
								yield return CreateParameter("Directions",entity.Directions);
								yield return CreateParameter("FloorNumber",entity.FloorNumber);
								yield return CreateParameter("MemberId",entity.MemberId);
								yield return CreateParameter("Street",entity.Street);
								yield return CreateParameter("ZipCode",entity.ZipCode);
						}
		protected override IEnumerable<System.Data.Common.DbParameter> GetUpdateParameters(MemberAddresses entity)
		{
							yield return CreateParameter("AddressId",entity.AddressId);
							yield return CreateParameter("AppartmentNumber",entity.AppartmentNumber);
							yield return CreateParameter("BuildingNumber",entity.BuildingNumber);
							yield return CreateParameter("Directions",entity.Directions);
							yield return CreateParameter("FloorNumber",entity.FloorNumber);
							yield return CreateParameter("MemberId",entity.MemberId);
							yield return CreateParameter("Street",entity.Street);
							yield return CreateParameter("ZipCode",entity.ZipCode);
					}
		protected override IEnumerable<System.Data.Common.DbParameter> GetDeleteParameters(System.Int32 identity)
		{
							yield return CreateParameter("AddressId",identity);
					}
        protected override string InsertProc
        {
            get { return "SP_MemberAddresses_Insert";}
		}
		
		protected override string UpdateProc
        {
            get { return "SP_MemberAddresses_Update";}
		}
		
		protected override string DeleteProc
        {
            get { return "SP_MemberAddresses_Delete";}
		}
		
		protected override string SelectProc
        {
            get { return "SP_MemberAddresses_Select";}
		}
		}
		#endregion
	
	#region [ CountriesRepository ]
	/// <summary>
	/// Repository for CRUD operations on Countries table 
	/// </summary>
	public class CountriesRepository : RepositoryBase< Countries,System.Int32,CountriesColumns >
	{
	 public CountriesRepository(string connectionStringName) : base(connectionStringName) { }
		protected override IEnumerable<System.Data.Common.DbParameter> GetInsertParameters(Countries entity)
		{
								yield return CreateParameter("CountryId",0,ParameterDirection.ReturnValue);
								yield return CreateParameter("CountryName",entity.CountryName);
						}
		protected override IEnumerable<System.Data.Common.DbParameter> GetUpdateParameters(Countries entity)
		{
							yield return CreateParameter("CountryId",entity.CountryId);
							yield return CreateParameter("CountryName",entity.CountryName);
					}
		protected override IEnumerable<System.Data.Common.DbParameter> GetDeleteParameters(System.Int32 identity)
		{
							yield return CreateParameter("CountryId",identity);
					}
        protected override string InsertProc
        {
            get { return "SP_Countries_Insert";}
		}
		
		protected override string UpdateProc
        {
            get { return "SP_Countries_Update";}
		}
		
		protected override string DeleteProc
        {
            get { return "SP_Countries_Delete";}
		}
		
		protected override string SelectProc
        {
            get { return "SP_Countries_Select";}
		}
		}
		#endregion
	
	#region [ NationalitiesRepository ]
	/// <summary>
	/// Repository for CRUD operations on Nationalities table 
	/// </summary>
	public class NationalitiesRepository : RepositoryBase< Nationalities,System.Int32,NationalitiesColumns >
	{
	 public NationalitiesRepository(string connectionStringName) : base(connectionStringName) { }
		protected override IEnumerable<System.Data.Common.DbParameter> GetInsertParameters(Nationalities entity)
		{
								yield return CreateParameter("NationalityId",0,ParameterDirection.ReturnValue);
								yield return CreateParameter("NationalityName",entity.NationalityName);
						}
		protected override IEnumerable<System.Data.Common.DbParameter> GetUpdateParameters(Nationalities entity)
		{
							yield return CreateParameter("NationalityId",entity.NationalityId);
							yield return CreateParameter("NationalityName",entity.NationalityName);
					}
		protected override IEnumerable<System.Data.Common.DbParameter> GetDeleteParameters(System.Int32 identity)
		{
							yield return CreateParameter("NationalityId",identity);
					}
        protected override string InsertProc
        {
            get { return "SP_Nationalities_Insert";}
		}
		
		protected override string UpdateProc
        {
            get { return "SP_Nationalities_Update";}
		}
		
		protected override string DeleteProc
        {
            get { return "SP_Nationalities_Delete";}
		}
		
		protected override string SelectProc
        {
            get { return "SP_Nationalities_Select";}
		}
		}
		#endregion
	
	#region [ ModulesRepository ]
	/// <summary>
	/// Repository for CRUD operations on Modules table 
	/// </summary>
	public class ModulesRepository : RepositoryBase< Modules,System.Int32,ModulesColumns >
	{
	 public ModulesRepository(string connectionStringName) : base(connectionStringName) { }
		protected override IEnumerable<System.Data.Common.DbParameter> GetInsertParameters(Modules entity)
		{
								yield return CreateParameter("ModuleId",0,ParameterDirection.ReturnValue);
								yield return CreateParameter("ModuleName",entity.ModuleName);
						}
		protected override IEnumerable<System.Data.Common.DbParameter> GetUpdateParameters(Modules entity)
		{
							yield return CreateParameter("ModuleId",entity.ModuleId);
							yield return CreateParameter("ModuleName",entity.ModuleName);
					}
		protected override IEnumerable<System.Data.Common.DbParameter> GetDeleteParameters(System.Int32 identity)
		{
							yield return CreateParameter("ModuleId",identity);
					}
        protected override string InsertProc
        {
            get { return "SP_Modules_Insert";}
		}
		
		protected override string UpdateProc
        {
            get { return "SP_Modules_Update";}
		}
		
		protected override string DeleteProc
        {
            get { return "SP_Modules_Delete";}
		}
		
		protected override string SelectProc
        {
            get { return "SP_Modules_Select";}
		}
		}
		#endregion
	
	#region [ NewsRepository ]
	/// <summary>
	/// Repository for CRUD operations on News table 
	/// </summary>
	public class NewsRepository : RepositoryBase< News,System.Int32,NewsColumns >
	{
	 public NewsRepository(string connectionStringName) : base(connectionStringName) { }
		protected override IEnumerable<System.Data.Common.DbParameter> GetInsertParameters(News entity)
		{
							yield return CreateParameter("CreationDate",entity.CreationDate);
								yield return CreateParameter("Description",entity.Description);
								yield return CreateParameter("Link",entity.Link);
									yield return CreateParameter("NewsId",0,ParameterDirection.ReturnValue);
								yield return CreateParameter("Title",entity.Title);
						}
		protected override IEnumerable<System.Data.Common.DbParameter> GetUpdateParameters(News entity)
		{
							yield return CreateParameter("CreationDate",entity.CreationDate);
							yield return CreateParameter("Description",entity.Description);
							yield return CreateParameter("Link",entity.Link);
							yield return CreateParameter("NewsId",entity.NewsId);
							yield return CreateParameter("Title",entity.Title);
					}
		protected override IEnumerable<System.Data.Common.DbParameter> GetDeleteParameters(System.Int32 identity)
		{
							yield return CreateParameter("NewsId",identity);
					}
        protected override string InsertProc
        {
            get { return "SP_News_Insert";}
		}
		
		protected override string UpdateProc
        {
            get { return "SP_News_Update";}
		}
		
		protected override string DeleteProc
        {
            get { return "SP_News_Delete";}
		}
		
		protected override string SelectProc
        {
            get { return "SP_News_Select";}
		}
		}
		#endregion
	
	#region [ MemberCommittiesRepository ]
	/// <summary>
	/// Repository for CRUD operations on MemberCommitties table 
	/// </summary>
	public class MemberCommittiesRepository : RepositoryBase< MemberCommitties,System.Int32,MemberCommittiesColumns >
	{
	 public MemberCommittiesRepository(string connectionStringName) : base(connectionStringName) { }
		protected override IEnumerable<System.Data.Common.DbParameter> GetInsertParameters(MemberCommitties entity)
		{
							yield return CreateParameter("Church",entity.Church);
									yield return CreateParameter("CommittieID",0,ParameterDirection.ReturnValue);
								yield return CreateParameter("DayOfMonth",entity.DayOfMonth);
								yield return CreateParameter("DayOfWeek",entity.DayOfWeek);
								yield return CreateParameter("IsServant",entity.IsServant);
								yield return CreateParameter("MemberId",entity.MemberId);
								yield return CreateParameter("Name",entity.Name);
								yield return CreateParameter("OccurreEveryMonths",entity.OccurreEveryMonths);
								yield return CreateParameter("OccurreEveryWeeks",entity.OccurreEveryWeeks);
								yield return CreateParameter("OccurrenceType",entity.OccurrenceType);
								yield return CreateParameter("ServantType",entity.ServantType);
								yield return CreateParameter("TimeOfWeek",entity.TimeOfWeek);
								yield return CreateParameter("WeekOfMonth",entity.WeekOfMonth);
						}
		protected override IEnumerable<System.Data.Common.DbParameter> GetUpdateParameters(MemberCommitties entity)
		{
							yield return CreateParameter("Church",entity.Church);
							yield return CreateParameter("CommittieID",entity.CommittieID);
							yield return CreateParameter("DayOfMonth",entity.DayOfMonth);
							yield return CreateParameter("DayOfWeek",entity.DayOfWeek);
							yield return CreateParameter("IsServant",entity.IsServant);
							yield return CreateParameter("MemberId",entity.MemberId);
							yield return CreateParameter("Name",entity.Name);
							yield return CreateParameter("OccurreEveryMonths",entity.OccurreEveryMonths);
							yield return CreateParameter("OccurreEveryWeeks",entity.OccurreEveryWeeks);
							yield return CreateParameter("OccurrenceType",entity.OccurrenceType);
							yield return CreateParameter("ServantType",entity.ServantType);
							yield return CreateParameter("TimeOfWeek",entity.TimeOfWeek);
							yield return CreateParameter("WeekOfMonth",entity.WeekOfMonth);
					}
		protected override IEnumerable<System.Data.Common.DbParameter> GetDeleteParameters(System.Int32 identity)
		{
							yield return CreateParameter("CommittieID",identity);
					}
        protected override string InsertProc
        {
            get { return "SP_MemberCommitties_Insert";}
		}
		
		protected override string UpdateProc
        {
            get { return "SP_MemberCommitties_Update";}
		}
		
		protected override string DeleteProc
        {
            get { return "SP_MemberCommitties_Delete";}
		}
		
		protected override string SelectProc
        {
            get { return "SP_MemberCommitties_Select";}
		}
		}
		#endregion
	
	#region [ MemberEducationRepository ]
	/// <summary>
	/// Repository for CRUD operations on MemberEducation table 
	/// </summary>
	public class MemberEducationRepository : RepositoryBase< MemberEducation,System.Int32,MemberEducationColumns >
	{
	 public MemberEducationRepository(string connectionStringName) : base(connectionStringName) { }
		protected override IEnumerable<System.Data.Common.DbParameter> GetInsertParameters(MemberEducation entity)
		{
								yield return CreateParameter("EducationId",0,ParameterDirection.ReturnValue);
								yield return CreateParameter("MemberId",entity.MemberId);
								yield return CreateParameter("Name",entity.Name);
								yield return CreateParameter("Type",entity.Type);
								yield return CreateParameter("Year",entity.Year);
						}
		protected override IEnumerable<System.Data.Common.DbParameter> GetUpdateParameters(MemberEducation entity)
		{
							yield return CreateParameter("EducationId",entity.EducationId);
							yield return CreateParameter("MemberId",entity.MemberId);
							yield return CreateParameter("Name",entity.Name);
							yield return CreateParameter("Type",entity.Type);
							yield return CreateParameter("Year",entity.Year);
					}
		protected override IEnumerable<System.Data.Common.DbParameter> GetDeleteParameters(System.Int32 identity)
		{
							yield return CreateParameter("EducationId",identity);
					}
        protected override string InsertProc
        {
            get { return "SP_MemberEducation_Insert";}
		}
		
		protected override string UpdateProc
        {
            get { return "SP_MemberEducation_Update";}
		}
		
		protected override string DeleteProc
        {
            get { return "SP_MemberEducation_Delete";}
		}
		
		protected override string SelectProc
        {
            get { return "SP_MemberEducation_Select";}
		}
		}
		#endregion
	
	#region [ MemberJobsRepository ]
	/// <summary>
	/// Repository for CRUD operations on MemberJobs table 
	/// </summary>
	public class MemberJobsRepository : RepositoryBase< MemberJobs,System.Int32,MemberJobsColumns >
	{
	 public MemberJobsRepository(string connectionStringName) : base(connectionStringName) { }
		protected override IEnumerable<System.Data.Common.DbParameter> GetInsertParameters(MemberJobs entity)
		{
							yield return CreateParameter("EmployedFrom",entity.EmployedFrom);
								yield return CreateParameter("EmployedTo",entity.EmployedTo);
								yield return CreateParameter("Employeer",entity.Employeer);
								yield return CreateParameter("IsCurrentJob",entity.IsCurrentJob);
									yield return CreateParameter("JobId",0,ParameterDirection.ReturnValue);
								yield return CreateParameter("MemberId",entity.MemberId);
								yield return CreateParameter("Position",entity.Position);
						}
		protected override IEnumerable<System.Data.Common.DbParameter> GetUpdateParameters(MemberJobs entity)
		{
							yield return CreateParameter("EmployedFrom",entity.EmployedFrom);
							yield return CreateParameter("EmployedTo",entity.EmployedTo);
							yield return CreateParameter("Employeer",entity.Employeer);
							yield return CreateParameter("IsCurrentJob",entity.IsCurrentJob);
							yield return CreateParameter("JobId",entity.JobId);
							yield return CreateParameter("MemberId",entity.MemberId);
							yield return CreateParameter("Position",entity.Position);
					}
		protected override IEnumerable<System.Data.Common.DbParameter> GetDeleteParameters(System.Int32 identity)
		{
							yield return CreateParameter("JobId",identity);
					}
        protected override string InsertProc
        {
            get { return "SP_MemberJobs_Insert";}
		}
		
		protected override string UpdateProc
        {
            get { return "SP_MemberJobs_Update";}
		}
		
		protected override string DeleteProc
        {
            get { return "SP_MemberJobs_Delete";}
		}
		
		protected override string SelectProc
        {
            get { return "SP_MemberJobs_Select";}
		}
		}
		#endregion
	
	#region [ EmailsRepository ]
	/// <summary>
	/// Repository for CRUD operations on Emails table 
	/// </summary>
	public class EmailsRepository : RepositoryBase< Emails,System.Int32,EmailsColumns >
	{
	 public EmailsRepository(string connectionStringName) : base(connectionStringName) { }
		protected override IEnumerable<System.Data.Common.DbParameter> GetInsertParameters(Emails entity)
		{
							yield return CreateParameter("Code",entity.Code);
								yield return CreateParameter("Description",entity.Description);
									yield return CreateParameter("EmailId",0,ParameterDirection.ReturnValue);
								yield return CreateParameter("Subject",entity.Subject);
								yield return CreateParameter("Template",entity.Template);
								yield return CreateParameter("TemplateResourcesPaths",entity.TemplateResourcesPaths);
						}
		protected override IEnumerable<System.Data.Common.DbParameter> GetUpdateParameters(Emails entity)
		{
							yield return CreateParameter("Code",entity.Code);
							yield return CreateParameter("Description",entity.Description);
							yield return CreateParameter("EmailId",entity.EmailId);
							yield return CreateParameter("Subject",entity.Subject);
							yield return CreateParameter("Template",entity.Template);
							yield return CreateParameter("TemplateResourcesPaths",entity.TemplateResourcesPaths);
					}
		protected override IEnumerable<System.Data.Common.DbParameter> GetDeleteParameters(System.Int32 identity)
		{
							yield return CreateParameter("EmailId",identity);
					}
        protected override string InsertProc
        {
            get { return "SP_Emails_Insert";}
		}
		
		protected override string UpdateProc
        {
            get { return "SP_Emails_Update";}
		}
		
		protected override string DeleteProc
        {
            get { return "SP_Emails_Delete";}
		}
		
		protected override string SelectProc
        {
            get { return "SP_Emails_Select";}
		}
		}
		#endregion
	
	#region [ ErrorsRepository ]
	/// <summary>
	/// Repository for CRUD operations on Errors table 
	/// </summary>
	public class ErrorsRepository : RepositoryBase< Errors,System.Int32,ErrorsColumns >
	{
	 public ErrorsRepository(string connectionStringName) : base(connectionStringName) { }
		protected override IEnumerable<System.Data.Common.DbParameter> GetInsertParameters(Errors entity)
		{
							yield return CreateParameter("Code",entity.Code);
								yield return CreateParameter("Description",entity.Description);
									yield return CreateParameter("ErrorId",0,ParameterDirection.ReturnValue);
								yield return CreateParameter("Message",entity.Message);
						}
		protected override IEnumerable<System.Data.Common.DbParameter> GetUpdateParameters(Errors entity)
		{
							yield return CreateParameter("Code",entity.Code);
							yield return CreateParameter("Description",entity.Description);
							yield return CreateParameter("ErrorId",entity.ErrorId);
							yield return CreateParameter("Message",entity.Message);
					}
		protected override IEnumerable<System.Data.Common.DbParameter> GetDeleteParameters(System.Int32 identity)
		{
							yield return CreateParameter("ErrorId",identity);
					}
        protected override string InsertProc
        {
            get { return "SP_Errors_Insert";}
		}
		
		protected override string UpdateProc
        {
            get { return "SP_Errors_Update";}
		}
		
		protected override string DeleteProc
        {
            get { return "SP_Errors_Delete";}
		}
		
		protected override string SelectProc
        {
            get { return "SP_Errors_Select";}
		}
		}
		#endregion
	
	#region [ NotificationsRepository ]
	/// <summary>
	/// Repository for CRUD operations on Notifications table 
	/// </summary>
	public class NotificationsRepository : RepositoryBase< Notifications,System.Int32,NotificationsColumns >
	{
	 public NotificationsRepository(string connectionStringName) : base(connectionStringName) { }
		protected override IEnumerable<System.Data.Common.DbParameter> GetInsertParameters(Notifications entity)
		{
							yield return CreateParameter("Code",entity.Code);
								yield return CreateParameter("Description",entity.Description);
									yield return CreateParameter("NotificationId",0,ParameterDirection.ReturnValue);
								yield return CreateParameter("Template",entity.Template);
						}
		protected override IEnumerable<System.Data.Common.DbParameter> GetUpdateParameters(Notifications entity)
		{
							yield return CreateParameter("Code",entity.Code);
							yield return CreateParameter("Description",entity.Description);
							yield return CreateParameter("NotificationId",entity.NotificationId);
							yield return CreateParameter("Template",entity.Template);
					}
		protected override IEnumerable<System.Data.Common.DbParameter> GetDeleteParameters(System.Int32 identity)
		{
							yield return CreateParameter("NotificationId",identity);
					}
        protected override string InsertProc
        {
            get { return "SP_Notifications_Insert";}
		}
		
		protected override string UpdateProc
        {
            get { return "SP_Notifications_Update";}
		}
		
		protected override string DeleteProc
        {
            get { return "SP_Notifications_Delete";}
		}
		
		protected override string SelectProc
        {
            get { return "SP_Notifications_Select";}
		}
		}
		#endregion
}
